BLOG

Learn the fundamentals of SQL++ queries for JSON

Read The Blog

Use powerful SQL with Couchbase

SQL++ is SQL for JSON with industry-standard ANSI syntax. SQL++ supports common concepts like ACID transactions, hierarchical schema called scopes, and joins across documents. It also takes advantage of our patented cost-based optimization. Take the tutorial to learn more.

Use SQL++ to overcome tough query challenges

Cost-efficient

Changing queries to a new language is costly. SQL++ meets ANSI 92 standards, which makes migration to Couchbase faster and easier.

Migration tips
Fast

Writing queries can be complex and lead to slow speeds if executed incorrectly. Our cost-based optimizer (CBO) ensures the best performance.

Go faster
Consistent

Using multiple databases for an application leads to data inconsistency. Couchbase can support all your use cases with a single multi-model database.

Learn more
Familiar

Learning a new proprietary query language for a database is challenging. SQL++ allows developers to use their existing SQL skills for JSON.

Customer story

SQL++ key capabilities

SQL++ provides teams with powerful ways to interact with data and develop faster queries to support critical applications.

Global Secondary Indexes (GSI)

GSIs enable low-latency queries for interactive applications. They support collection-level processing.

Indexing innovations

Couchbase includes composite and array indexes and a function that identifies the best index for SQL++ queries.

Multi-dimensional scaling (MDS)

MDS delivers workload isolation of various microservices so you can scale out the service you need when you need it.

Full-text search (FTS)

Built-in language-aware text searching enables users to quickly obtain the most relevant documents based on scoring.

SQL++: SQL-like queries with the flexibility of JSON

Develop engaging applications with ease using a comprehensive and declarative JSON query language. Developers can rapidly adapt to changing business requirements using a schemaless JSON document store.

Query without compromise, with capabilities you expect from SQL queries

SQL++ is a high-performance NoSQL query language with built-in optimizers and indexer enablers to support millions of concurrent interactions with sub-millisecond latencies. Couchbase’s multi-dimensional architecture uses SQL++ across its query, index, search, and analytics services, partitioning to elastically scale data capacity and deliver accelerated query performance.

Familiar tooling makes query development and optimization a breeze

SQL++ is accessed through the Query Workbench and has a built-in index advice feature that tells the developer what indexes are needed to optimize their query. Flex Index uses the inverted search index from the Full-Text Search Service for complicated query predicates. Couchbase also includes a cost-based optimizer and JavaScript-based user-defined functions to manipulate the resulting data.

What customers are saying

“We quickly realized that Couchbase offers the flexibility to search with a language that looks 99% the same as SQL. So for all developers, it was an easy transition.”
Fidencio Garrido, Principal Engineer, DirecTV
38M+ customers
3K+ channels
Read Customer Story See all stories
“Within three months, we built a virtual platform to host a conference with over forty thousand attendees. Our partnership with Couchbase made it possible.”
Brent Ryan, VP of Engineering, Cvent
8 development clusters
100+ microservices
Read Customer Story See all stories
“We extensively use SQL++ for structured querying, and with full-text search we can seamlessly search and derive relevance-based intelligence.”
Dave Starling, CTO, Seenit
92% faster implementation for new feature
Read Customer Story See all stories
“We’re able to put data to work in a more efficient way, and we’ve built a strong foundation for the future.”
Arvind Jade, Architect Lead, Nielsen
80% increased change management efficiency
50% boost in response time
Read Customer Story See all stories
Try SQL++ in the Capella playground

Get hands on with SQL++ using our interactive tool in the Capella UI.

Enter Playground

Explore related resources

DATASHEET
Couchbase SQL++: The power of SQL meets JSON flexibility
Read the datasheet
WHITEPAPER
Moving from relational to NoSQL: How to get started from Oracle
Read the paper
VIDEO
Don Chamberlin (SQL inventor) on NoSQL and SQL++
Watch the video
See All Resources
Start building

Check out our developer portal to explore NoSQL, browse resources, and get started with tutorials.

Develop now
Use our free DBaaS

Get hands-on with Couchbase in just a few clicks. Capella DBaaS is the easiest and fastest way to get started.

Use free
Join a free Capella Test-Drive

Kick off your Couchbase Certification journey in 90 minutes with a dedicated instructor.

Get started